All files / web/src/app/api/curriculum/[playerId]/attachments route.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
/**
 * API route for player attachments
 *
 * GET /api/curriculum/[playerId]/attachments
 *
 * Returns attachment counts grouped by session ID for display in session history.
 */

import { NextResponse } from 'next/server'
import { eq, sql } from 'drizzle-orm'
import { db } from '@/db'
import { practiceAttachments } from '@/db/schema'
import { withAuth } from '@/lib/auth/withAuth'
import { canPerformAction } from '@/lib/classroom'
import { getUserId } from '@/lib/viewer'

/**
 * GET - Get attachment counts per session
 */
export const GET = withAuth(async (_request, { params }) => {
  try {
    const { playerId } = (await params) as { playerId: string }

    if (!playerId) {
      return NextResponse.json({ error: 'Player ID required' }, { status: 400 })
    }

    // Authorization check
    const userId = await getUserId()
    const canView = await canPerformAction(userId, playerId, 'view')
    if (!canView) {
      return NextResponse.json({ error: 'Not authorized' }, { status: 403 })
    }

    // Get attachment counts grouped by session
    const counts = await db
      .select({
        sessionId: practiceAttachments.sessionId,
        count: sql<number>`count(*)`.as('count'),
      })
      .from(practiceAttachments)
      .where(eq(practiceAttachments.playerId, playerId))
      .groupBy(practiceAttachments.sessionId)
      .all()

    // Transform to a map for easy lookup
    const sessionCounts: Record<string, number> = {}
    for (const row of counts) {
      sessionCounts[row.sessionId] = row.count
    }

    return NextResponse.json({ sessionCounts })
  } catch (error) {
    console.error('Error fetching attachment counts:', error)
    return NextResponse.json({ error: 'Failed to fetch attachment counts' }, { status: 500 })
  }
})